home
diamond Go Premium
Data Engineering Path  ·  Data Modelling
UBER & RIDE-SHARING CASE STUDY

Table riders { rider_id int [pk, increment] first_name varchar last_name varchar email varchar [unique] rating decimal }

Table drivers { driver_id int [pk, increment] first_name varchar last_name varchar status varchar [note: "offline, active_idle, on_trip"] rating decimal }

Table vehicles { vehicle_id int [pk, increment] driver_id int [ref: > drivers.driver_id] plate_number varchar model varchar }

Table trips { trip_id int [pk, increment] rider_id int [ref: > riders.rider_id] driver_id int [ref: > drivers.driver_id, null] pickup_lat decimal pickup_lng decimal drop_lat decimal drop_lng decimal status varchar fare decimal requested_at timestamp }

lock

This content is reserved for Premium Members.

Upgrade to Premium

Entity Details

Create New Item

help

Submit Technical Query

Have a question or run into an issue? Describe it below, upload an optional screenshot, and our engineering team will answer it!

image Attach image (optional)

Submit Feedback

build Free Developer Utility Free Tool
gavel

Privacy & Legal Disclaimer

1. Client-Side Browser Processing

All utility tools on DeepEngineerHub (including Image to PDF, Text Formatters, JSON Converters, and Encryptors) execute 100% locally within your client browser using WebAssembly and JavaScript. No uploaded images, text, or documents are transmitted, collected, or stored on remote servers.

2. Limitation of Liability ("As-Is" Provision)

Tools and services are provided free of charge for convenience and educational purposes "as-is" without warranties of any kind. DeepEngineerHub shall not be held liable for any data loss, formatting inconsistencies, or indirect damages resulting from tool usage.

3. Open Source & Third-Party Software

Certain utilities utilize open-source client libraries (such as jsPDF, Mermaid.js, Pyodide) licensed under MIT, Apache, or BSD open licenses. All intellectual property remains with their respective copyright holders.